/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package db;

import java.sql.ResultSet;
import java.util.ArrayList;
import models.Person;

/**
 *
 * @author pelle
 */
public interface PersonInterface {
    public int getMemberCount();
    public int getTrainerCount();
    public Person getPersonById(int id);
    public Person getPersonById(int id, boolean getExtra);
    public Person getPersonByEmail(String email);
    public Person buildPerson(ResultSet rs);
    public Person buildPerson(ResultSet rs, boolean getExtra);
    public int savePerson(Person person);
    public String getCityFromZipcode(int zipcode);
    public ArrayList<Person> searchPersons(String name, String email, String phone, String cpr, ArrayList<String> roles);
    public ArrayList<Person> getAllPersons();
}
